SQL Tutorial Home

How to Add a Default Value to a Column

In order to add a default value in Postgres, you need to use the alter table with the set default clause:

alter table employee alter column last_bonus set default current_date;